Databases in Delphi


One of the most big changes in Delphi world is the support of Databases. Turbo Pascal
lacks the libraries that support the accessibility to standard databases.
In the first release of Delphi, Borland introduces a new technology of accessing
Desktop databases such as
Paradox, DBase, Access, Foxpro... , and Database servers
such as
Oracle, MS-SQL, Sybase, InterBase, Informix, etc. Borland  developed big
libraries for Delphi and C++Cuilder called
BDE (Borland Database Engine). This engine
existed befor Delphi, and formally it was called
IDAPI (Independent Database Application
Programming Interface). The goal of these libraries is to support a wide varity of
standard databases in a transparent method, to shield the programmer of deep details
and structure of each database format. By using
BDE you can write applications that
uses
Paradox tables and then you can use Foxpro tables without modifing your code,
and you can easily move to Database Servers.
BDE is a Windows Dynamic Link Libraries (DLLs) so that it can be shared between
your applications. If you want to deploy applications that use the BDE you must install
the
BDE in that computer. Another time you will not need to install the BDE if you
want to deploy new Database applications because it needs to be installed once in
the client computers. The size of
BDE libraries is about 4 Megabytes.
BDE is the competitor of Microsoft's ODBC (Open DataBase Connectivity), and it is
more faster than it.


Use InstallShield Express wizard to setup your applications and to copy the BDE libraries
with your applications. The only thing you need to do is to specify the database
driver you used, for example (
Paradox, DBase, or Foxpro) or you can make a full packing
of the entire
BDE libraries. InstallShield Express is shipped with Delphi CD.